UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aW5P4pC0izvVf4itPKJdEae4cqD7Cv9z5TPdksrkXhc='
WHERE
key_id = 'd4cd459668a7352e53b2ce037dcfe6168fafc359b42e555dfa19c837aef479ae'
AND (
token = 'aW5P4pC0izvVf4itPKJdEae4cqD7Cv9z5TPdksrkXhc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)