UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '27D2IIU2mLgeY6CR0L5xpXKCLhSGC9b5h18ACn1LfUc='
WHERE
key_id = 'b9aad706579abc29e51ac14570e42f74d65f2ef32a08f285f2177413036eb801'
AND (
token = '27D2IIU2mLgeY6CR0L5xpXKCLhSGC9b5h18ACn1LfUc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)