UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7LLmWsDux9Ik36O5lg3NYfUheYN9Ld8qtKF47SEV7Lw='
WHERE
key_id = 'aa56a250baca70ed9e17e3712fd6f49bbb2db962c06bc96ee0f2e9bf345def66'
AND (
token = '7LLmWsDux9Ik36O5lg3NYfUheYN9Ld8qtKF47SEV7Lw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)