UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '46W+m30rWYZVnMdkFJdB95hv4LGYlGquGxwb740qK3M='
WHERE
key_id = 'e729ee0056f8fbc2b52d944e5a2f127737aa1153b5349c9950e70b03d638da40'
AND (
token = '46W+m30rWYZVnMdkFJdB95hv4LGYlGquGxwb740qK3M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)