UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'utecbZX9yUwetLVgeWyvipp9MBoojjIslkfv340VpRs='
WHERE
key_id = '02d7dca9f7f1d00fa8ef1aa59891b48464bffbf9115f9af15ccc923bb1bc2942'
AND (
token = 'utecbZX9yUwetLVgeWyvipp9MBoojjIslkfv340VpRs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)