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