UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a7+BkGJ35PUlq1iHBuQlV96xfjogrzc7bvCmmUgBoco='
WHERE
key_id = '0afaba5f9b4344c948cfd17ee0ff8b48c97c574d7e8b02f1df9127d726454cde'
AND (
token = 'a7+BkGJ35PUlq1iHBuQlV96xfjogrzc7bvCmmUgBoco='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)