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