UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AiFnbJGFZE6OemFhJmGF7DiyG226ZDFQLFNKdiSVOZI='
WHERE
key_id = 'c1a571bfcbc946505b5dfc502b0a20d37bb682a38fa49d259a64064c6ee50458'
AND (
token = 'AiFnbJGFZE6OemFhJmGF7DiyG226ZDFQLFNKdiSVOZI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)