UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bqyqRe2YFt8QrPJZBnV/hezxuELY1tEYsZV6Sf20wC8='
WHERE
key_id = 'd9571b0bc11be429e8ee7e2a504acb7027e8f6f498c851b63d4f84eb8a290dcb'
AND (
token = 'bqyqRe2YFt8QrPJZBnV/hezxuELY1tEYsZV6Sf20wC8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)