UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7KKgUSoN1b7Z7UDJapf8IkcFZ7No9TiKLUmgf9/KVEA='
WHERE
key_id = 'dd27ed2a1ea68fd495bc7bf78f5fa83b2472cc2d8d6fb32d74abb8dc8fce8610'
AND (
token = '7KKgUSoN1b7Z7UDJapf8IkcFZ7No9TiKLUmgf9/KVEA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)