UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tWnR1ozkY6ZEKf4J4i9mNyqLre3igFcoW7nOqWBKh4I='
WHERE
key_id = 'd93ddf07b548e65c0b317c0043c90f46e3468483732c52a3807fc560ebab3cdc'
AND (
token = 'tWnR1ozkY6ZEKf4J4i9mNyqLre3igFcoW7nOqWBKh4I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)