UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9b3QG0tCeI+dm00vU1t2kLSPzF/McSnIe1VJNKPoHak='
WHERE
key_id = '8f6f4b0120ad5c248962c1880b81c0732601888e49339292424a29e443299867'
AND (
token = '9b3QG0tCeI+dm00vU1t2kLSPzF/McSnIe1VJNKPoHak='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)