UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0C+6HyXbjhYmwzzSO3akn3sV3xsPL8kkpetl4R9ckvU='
WHERE
key_id = '5516a64e3e815085cd7bb71ea2abb0bc5834326265a3f190066f03b7647fbf62'
AND (
token = '0C+6HyXbjhYmwzzSO3akn3sV3xsPL8kkpetl4R9ckvU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)