UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+Q7J7MCkYHNW3Fgj4p9zhtq/6lnWhy7e3KChpyHq1jk='
WHERE
key_id = 'f4b6fb95d3ebe48f4bc0e884d2fc0cb3bd155ce5c2bd83c7812ca870c2bc99dc'
AND (
token = '+Q7J7MCkYHNW3Fgj4p9zhtq/6lnWhy7e3KChpyHq1jk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)