UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0ISZ9mRglnY3y/Yx8ODvsU+XAlyxv7fjOrFRJAI9lxM='
WHERE
key_id = '7bb6eeb9b701e9f85c833c17d5a280ea767111f6978e1f4e9459154169a021a3'
AND (
token = '0ISZ9mRglnY3y/Yx8ODvsU+XAlyxv7fjOrFRJAI9lxM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)