UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mdW8Ng6hr798rMLKugJIv8A2hnt/QgZlug66bBZbzdw='
WHERE
key_id = '5d826e41d0068d51787fd8ec2a4f1478f2578286c5a5085a49864760fe68a406'
AND (
token = 'mdW8Ng6hr798rMLKugJIv8A2hnt/QgZlug66bBZbzdw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)