UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wIg2M+hIRc/9UHs66pfTfG6cEX4vBXW2gSaabv6hOhI='
WHERE
key_id = '3afc282f7317004893cc16b7ebf43b12b1faeb775f6ba39fbe08a1c6b8c5bc46'
AND (
token = 'wIg2M+hIRc/9UHs66pfTfG6cEX4vBXW2gSaabv6hOhI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)