UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LDtJxm8ouf9erLfMkhLMUtUO6lnYX8u7igmnI2E59Kk='
WHERE
key_id = '80825e52e475e3f6b25d835352a3549799c376bbe029266d372aefa3cb7b7ab4'
AND (
token = 'LDtJxm8ouf9erLfMkhLMUtUO6lnYX8u7igmnI2E59Kk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)