UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8YM+zWuHoOUuaUSnoTQoeBARGbKuj520UYbrihlzJpo='
WHERE
key_id = '74ed5a37149e683b9a13c186e801862c1fe92665b0cd6b9f69dc882ed229b70e'
AND (
token = '8YM+zWuHoOUuaUSnoTQoeBARGbKuj520UYbrihlzJpo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)