UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MpBKL0MKycbPJwrc5oNXB2ajY3fCkMMYw2nczgRIhkQ='
WHERE
key_id = '2d308c6466711896ab7484a2f49660c9bfabd054b9c5d322ee71b0253288df33'
AND (
token = 'MpBKL0MKycbPJwrc5oNXB2ajY3fCkMMYw2nczgRIhkQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)