UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J56t4Cust0rTYwEee1Fhbi8wExjbne6VuptQkG4dOsA='
WHERE
key_id = '22b996ccc256aefb44228f59d49c2a14615e72185765e62dbfd28e073e7b75cd'
AND (
token = 'J56t4Cust0rTYwEee1Fhbi8wExjbne6VuptQkG4dOsA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)