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