UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B94hn/ALYbjk4CAuDgKxIJQ9rL9kqlGkCu5p4b+22QU='
WHERE
key_id = 'e436555ea5c991cd46caea1a52afadf44967f5e77a11efb6a9243cea6cfc43f7'
AND (
token = 'B94hn/ALYbjk4CAuDgKxIJQ9rL9kqlGkCu5p4b+22QU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)