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