UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5C6IKbN6WrmVNi2LVC2JVxPITe1bxqFo1qYKARy5XOw='
WHERE
key_id = '0645dbba3660de63465c3b960ba3b26ab452d18b6f53ee0f838b7d97ace60fa2'
AND (
token = '5C6IKbN6WrmVNi2LVC2JVxPITe1bxqFo1qYKARy5XOw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)