UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'O7CIFk1uiGDpJ+poU8EUJiCbrYEk00PTmjyum65R85U='
WHERE
key_id = 'd8b7962b91acbac768105ee01a2688aeb3f9fb50cc47b7c51c379bfbbf285edf'
AND (
token = 'O7CIFk1uiGDpJ+poU8EUJiCbrYEk00PTmjyum65R85U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)