UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 't+C+3skZlmndZjNo2tdJ1J2Bhp9INp5e88K7V1h6wG8='
WHERE
key_id = '7f1e2a53c77d307b0106496bd0cbc1d70b91a073f82af4429aed74790daaf56e'
AND (
token = 't+C+3skZlmndZjNo2tdJ1J2Bhp9INp5e88K7V1h6wG8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)