UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xM7D9ZbIMH/asWqQhNwOFaBdtLO6XClcjs7++T30Dq0='
WHERE
key_id = 'b51227d0cc0f72f723218951675762cf8632a324170e98c8e6362050b317a649'
AND (
token = 'xM7D9ZbIMH/asWqQhNwOFaBdtLO6XClcjs7++T30Dq0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)