UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9T2IpVW07d4hbpRRs50mAMBPICyPkZRR5rk3CNtosTA='
WHERE
key_id = 'c1c60e8c090e8b29ea54681f2829caa4484606ab23dbacd25e37e403cc2e8c1f'
AND (
token = '9T2IpVW07d4hbpRRs50mAMBPICyPkZRR5rk3CNtosTA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)