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