UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UmLy8sAaCFaoFn+YhpcGHDDutYlBhv1M9u93MLn53sk='
WHERE
key_id = 'a1c90662dbdb63d9593d7791b6fae3edd9894daacd76c90feb1d0c3e6612410f'
AND (
token = 'UmLy8sAaCFaoFn+YhpcGHDDutYlBhv1M9u93MLn53sk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)