UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rWAXs+iOAcwOD9XDAlwST6o3pFRj1dKaB8PHAOFCZgM='
WHERE
key_id = '5cacd3ef0a9db34e8668ea39724958a2468958a7fe82c61e0f13727f86c5936a'
AND (
token = 'rWAXs+iOAcwOD9XDAlwST6o3pFRj1dKaB8PHAOFCZgM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)