UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MC2w7x8mpjBaT426FqU0riytmlMlXvk7EQ/HHTiXLJ0='
WHERE
key_id = 'a1f6580919aeaf2990bbb8a62df014a31bc58330dec54d81e6bdbd293ffe07fb'
AND (
token = 'MC2w7x8mpjBaT426FqU0riytmlMlXvk7EQ/HHTiXLJ0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)