UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MJiK1GkYAaJYAi8jMMQGDzROpEPxG1/rfE8x5bsFJSY='
WHERE
key_id = '6ac8154d2077262826d67614a927e5f71c4703588479f99b12beb630fab3c118'
AND (
token = 'MJiK1GkYAaJYAi8jMMQGDzROpEPxG1/rfE8x5bsFJSY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)