UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PI8b5s5WNm48QLk6tdrRq1ZZTadg1J18m/slhRJsTm8='
WHERE
key_id = '1f3d99be23ffc617f1141d7a2e9dc65e5d839380509f23e76d700ca43d1d2eb4'
AND (
token = 'PI8b5s5WNm48QLk6tdrRq1ZZTadg1J18m/slhRJsTm8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)