UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VubKJ8RXHY7PTr0niOijd5bkFWWiyX2lv/oDZFbr69w='
WHERE
key_id = 'ce678ed3a2d1c942dc371d1b237889108fbecb5c8d7d3a8d2400bccdb3052632'
AND (
token = 'VubKJ8RXHY7PTr0niOijd5bkFWWiyX2lv/oDZFbr69w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)