UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6Yl4dhDNWKeC1mbpsZpbWtmxm3mbojHTje5JKBP4g8w='
WHERE
key_id = '5a46902de0c8403ed9c774a5150a7c0446bd9478769c82a0a136d2851ec9d5c5'
AND (
token = '6Yl4dhDNWKeC1mbpsZpbWtmxm3mbojHTje5JKBP4g8w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)