UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XxSx82cCQeAXJiB+M/z9iBIsqp5WkV6i+oHOlo//nbw='
WHERE
key_id = 'f7872b5636500b85f7dd8fd02d0f613159f0e24cb24c29c33f95a94672faae55'
AND (
token = 'XxSx82cCQeAXJiB+M/z9iBIsqp5WkV6i+oHOlo//nbw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)