UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U9kBSd5MJmSM9MIzPE2s4fcvgU3y8dYI78Z/EKdhy4o='
WHERE
key_id = 'cec2b4e98a5aa55eccf1d45e44d282970f13393c13f2858c4678de816b9511ac'
AND (
token = 'U9kBSd5MJmSM9MIzPE2s4fcvgU3y8dYI78Z/EKdhy4o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)