UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BjkHUBp6WuvDpeN9aZEdxX4CcpFxNeWlMuYPZlG2mWs='
WHERE
key_id = '06389df5ff0d38074f97949af1f4793dbce00b6be0799a0ec6996a5d354b41e6'
AND (
token = 'BjkHUBp6WuvDpeN9aZEdxX4CcpFxNeWlMuYPZlG2mWs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)